<?xml version="1.0"?>
<ChartConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" format="Png" width="600" height="400" xmlns="http://dev.buwog.at/schemas/ChartBuilder/v1">
  <DataSource name="dm_exec_sessions">
    <ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=.\SQLExpress</ConnectionString>
    <SqlCommand>select case when nt_user_name &lt;&gt; '' then nt_user_name else login_name end as login_name,
			cpu_time, total_scheduled_time, total_elapsed_time
			from sys.dm_exec_sessions
			where host_process_id is not null
			order by total_scheduled_time desc</SqlCommand>
  </DataSource>
  <Design xmlns="">
    <Chart Size="600, 400">
      <Series>
        <Series _Template_="0" XValueMember="login_name" YValueMembers="total_scheduled_time" Legend="Legend1" XValueType="String" YValueType="Int32" ChartType="Area" ChartArea="ChartArea1" LegendText="Activity">
        </Series>
        <Series _Template_="1" XValueMember="login_name" YValueMembers="total_elapsed_time" Legend="Legend1" XValueType="Double" YValueType="Double" ChartType="Line" ChartArea="ChartArea1" LegendText="Lifetime">
        </Series>
        <Series _Template_="2" XValueMember="login_name" YValueMembers="cpu_time" Legend="Legend1" XValueType="Double" YValueType="Double" ChartType="Line" ChartArea="ChartArea1" LegendText="CPU">
        </Series>
      </Series>
      <Legends>
        <Legend _Template_="All" DockedToChartArea="ChartArea1">
        </Legend>
      </Legends>
      <ChartAreas>
        <ChartArea _Template_="All" AlignmentOrientation="All">
          <Area3DStyle Enable3D="True" />
        </ChartArea>
      </ChartAreas>
    </Chart>
  </Design>
</ChartConfiguration>